package edu.cueb.wmis.mapper;

import edu.cueb.wmis.pojo.Orderbill;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author liuzizhuo
 * @since 2021-04-19
 */
public interface OrderbillMapper extends BaseMapper<Orderbill> {

    @Select("select id from tb_orderbill where billNumber = #{billNumber}")
    Integer getOrderItemsByBillNumber(String billNumber);
    @Update("UPDATE tb_orderbill SET state = 1 WHERE id = #{id}")
    void updateState(Integer id);
}
